{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Onkostendeclaratie"],"not_rendered":{"images":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Onkostendeclaratie","index":0,"n_rows":48,"n_cols":9,"rows_kept":48,"merged":[[0,1,0,2],[43,1,43,2],[43,4,43,5],[45,1,45,2],[45,4,45,5],[47,1,47,2],[47,4,47,5]]}
[]
[]
[null,"Naam Pleegouder"]
[{"$nulls":5},"LET OP!","Een declaratie OV dient altijd onderbouwd te worden met transacties. "]
[null,"Naam Pleegkind",null,"Geboortedatum pleegkind",null,null,"Een declaratie voor reiskosten indien mogelijk onderbouwen met afsprakenkaart"]
[]
[null,"Periode       (wordt automatisch ingevuld)",{"$f":"IF(MIN(B10:B40)=MAX(B10:B40),TEXT(MIN(B10:B40),\"d-m-jj\"),\"Van \"&TEXT(MIN(B10:B40),\"d-m-jj\")&\" tot \"&TEXT(MAX(B10:B40),\"d-m-jj\"))","v":"0-1-00"},"Datum indienen                     (wordt automatisch ingevuld)",{"$f":"TODAY()","v":"2023-02-20"}]
[]
[null,"Datum","Beschrijving van kosten","Vertrekpunt","Eindpunt","OV tarief ","Kilometers enkele reis","Retour? Ja/Nee","Totale kilometers"]
[{"$nulls":8},{"$f":"IF($H10=\"Ja\",$G10*2,$G10*1)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"$f":"IF($H20=\"Ja\",$G20*2,$G20*1)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"$f":"IF($H26=\"Ja\",$G26*2,$G26*1)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"$f":"IF($H36=\"Ja\",$G36*2,$G36*1)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"$f":"IF($H40=\"Ja\",$G40*2,$G40*1)","v":{"v":0,"d":"0.00"}}]
[null,"Totaal",{"$nulls":3},{"$f":"SUBTOTAL(109,Onkosten[[OV tarief ]])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Onkosten[Kilometers enkele reis])","v":{"v":0,"d":"0.00"}},null,{"$f":"SUBTOTAL(109,Onkosten[Totale kilometers])","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Onderstaande wordt ingevuld door Het Loket",null,"Onderstaande wordt ingevuld door Het Loket"]
[null,"Kilometervergoeding",null,{"v":0,"d":"€ 0.00"},"Totaal OV-tarief",null,{"$f":"F41","v":{"v":0,"d":"€ 0.00"}}]
[]
[null,"Eigen bijdrage ",null,{"v":0,"d":"€ 0.00"},"Eigen bijdrage ",null,{"v":0,"d":"€ 0.00"}]
[]
[null,"Totale vergoeding",null,{"$f":"SUM(I41*D44-D46)","v":{"v":0,"d":"€ 0.00"}},"Totale vergoeding",null,{"$f":"SUM(G44-G46)","v":{"v":0,"d":"€ 0.00"}}]